[dbo].[BAEGetCreditCardList]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEGetCreditCardList

Property	Value
ANSI Nulls On
Quoted Identifier On

create procedure [dbo].[BAEGetCreditCardList] as
DECLARE @CCPrefix varchar(10)

    SELECT @CCPrefix = CurrentValue FROM Configuration WHERE Variable = 'iMISCreditCardPrefix'
    SELECT @CCPrefix = REPLACE(@CCPrefix, '_', '[_]')

    SELECT CASH_ACCOUNT_CODE AS 'ccCode', DESCRIPTION AS 'ccType', CCAuthAcctCode AS 'ccAccount', ORG_CODE
    FROM Cash_Accounts
    WHERE CASH_ACCOUNT_CODE LIKE @CCPrefix + '%'

GO